Dataset statistics
| Number of variables | 23 |
|---|---|
| Number of observations | 182374 |
| Missing cells | 32476 |
| Missing cells (%) | 0.8% |
| Duplicate rows | 128 |
| Duplicate rows (%) | 0.1% |
| Total size in memory | 33.4 MiB |
| Average record size in memory | 192.0 B |
Variable types
| Categorical | 11 |
|---|---|
| DateTime | 2 |
| Text | 6 |
| Numeric | 4 |
Year has constant value "2023-24" | Constant |
Channel-2 has constant value "LFS" | Constant |
Billing grp has constant value "LFS" | Constant |
| Dataset has 128 (0.1%) duplicate rows | Duplicates |
Brand is highly imbalanced (92.1%) | Imbalance |
Region has 14357 (7.9%) missing values | Missing |
Franchisee store has 18119 (9.9%) missing values | Missing |
Quantity is highly skewed (γ1 = 24.45627323) | Skewed |
Reproduction
| Analysis started | 2024-05-21 04:45:45.762350 |
|---|---|
| Analysis finished | 2024-05-21 04:46:04.056272 |
| Duration | 18.29 seconds |
| Software version | ydata-profiling v4.8.3 |
| Download configuration | config.json |
Year
Categorical
CONSTANT
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.8 MiB |
| 2023-24 |
|---|
Length
| Max length | 7 |
|---|---|
| Median length | 7 |
| Mean length | 7 |
| Min length | 7 |
Characters and Unicode
| Total characters | 1276618 |
|---|---|
| Distinct characters | 5 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2023-24 |
|---|---|
| 2nd row | 2023-24 |
| 3rd row | 2023-24 |
| 4th row | 2023-24 |
| 5th row | 2023-24 |
Common Values
| Value | Count | Frequency (%) |
| 2023-24 | 182374 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 2023-24 | 182374 |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 547122 | |
| 0 | 182374 | 14.3% |
| 3 | 182374 | 14.3% |
| - | 182374 | 14.3% |
| 4 | 182374 | 14.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1276618 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 2 | 547122 | |
| 0 | 182374 | 14.3% |
| 3 | 182374 | 14.3% |
| - | 182374 | 14.3% |
| 4 | 182374 | 14.3% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1276618 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 2 | 547122 | |
| 0 | 182374 | 14.3% |
| 3 | 182374 | 14.3% |
| - | 182374 | 14.3% |
| 4 | 182374 | 14.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1276618 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 2 | 547122 | |
| 0 | 182374 | 14.3% |
| 3 | 182374 | 14.3% |
| - | 182374 | 14.3% |
| 4 | 182374 | 14.3% |
Month
Date
| Distinct | 40 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.8 MiB |
| Minimum | 2023-02-01 00:00:00 |
|---|---|
| Maximum | 2024-01-01 00:00:00 |
Histogram with fixed size bins (bins=40)
Month Key
Categorical
| Distinct | 11 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.8 MiB |
| Dec | |
|---|---|
| Jul | |
| Aug | |
| May | |
| Jun | |
| Other values (6) |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 547122 |
|---|---|
| Distinct characters | 22 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Apr |
|---|---|
| 2nd row | Apr |
| 3rd row | Apr |
| 4th row | Apr |
| 5th row | Apr |
Common Values
| Value | Count | Frequency (%) |
| Dec | 20659 | |
| Jul | 18119 | |
| Aug | 17510 | |
| May | 17340 | |
| Jun | 17298 | |
| Oct | 16884 | |
| Apr | 16354 | |
| Nov | 16164 | |
| Jan | 14694 | |
| Sep | 14085 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| dec | 20659 | |
| jul | 18119 | |
| aug | 17510 | |
| may | 17340 | |
| jun | 17298 | |
| oct | 16884 | |
| apr | 16354 | |
| nov | 16164 | |
| jan | 14694 | |
| sep | 14085 |
Most occurring characters
| Value | Count | Frequency (%) |
| u | 52927 | 9.7% |
| J | 50111 | 9.2% |
| e | 48011 | 8.8% |
| c | 37543 | 6.9% |
| A | 33864 | 6.2% |
| a | 32034 | 5.9% |
| n | 31992 | 5.8% |
| p | 30439 | 5.6% |
| D | 20659 | 3.8% |
| l | 18119 | 3.3% |
| Other values (12) | 191423 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 547122 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| u | 52927 | 9.7% |
| J | 50111 | 9.2% |
| e | 48011 | 8.8% |
| c | 37543 | 6.9% |
| A | 33864 | 6.2% |
| a | 32034 | 5.9% |
| n | 31992 | 5.8% |
| p | 30439 | 5.6% |
| D | 20659 | 3.8% |
| l | 18119 | 3.3% |
| Other values (12) | 191423 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 547122 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| u | 52927 | 9.7% |
| J | 50111 | 9.2% |
| e | 48011 | 8.8% |
| c | 37543 | 6.9% |
| A | 33864 | 6.2% |
| a | 32034 | 5.9% |
| n | 31992 | 5.8% |
| p | 30439 | 5.6% |
| D | 20659 | 3.8% |
| l | 18119 | 3.3% |
| Other values (12) | 191423 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 547122 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| u | 52927 | 9.7% |
| J | 50111 | 9.2% |
| e | 48011 | 8.8% |
| c | 37543 | 6.9% |
| A | 33864 | 6.2% |
| a | 32034 | 5.9% |
| n | 31992 | 5.8% |
| p | 30439 | 5.6% |
| D | 20659 | 3.8% |
| l | 18119 | 3.3% |
| Other values (12) | 191423 |
QTR
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.8 MiB |
| Q3 | |
|---|---|
| Q1 | |
| Q2 | |
| Q4 |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Characters and Unicode
| Total characters | 364748 |
|---|---|
| Distinct characters | 5 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Q1 |
|---|---|
| 2nd row | Q1 |
| 3rd row | Q1 |
| 4th row | Q1 |
| 5th row | Q1 |
Common Values
| Value | Count | Frequency (%) |
| Q3 | 53707 | |
| Q1 | 50992 | |
| Q2 | 49714 | |
| Q4 | 27961 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| q3 | 53707 | |
| q1 | 50992 | |
| q2 | 49714 | |
| q4 | 27961 |
Most occurring characters
| Value | Count | Frequency (%) |
| Q | 182374 | |
| 3 | 53707 | 14.7% |
| 1 | 50992 | 14.0% |
| 2 | 49714 | 13.6% |
| 4 | 27961 | 7.7% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 364748 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| Q | 182374 | |
| 3 | 53707 | 14.7% |
| 1 | 50992 | 14.0% |
| 2 | 49714 | 13.6% |
| 4 | 27961 | 7.7% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 364748 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| Q | 182374 | |
| 3 | 53707 | 14.7% |
| 1 | 50992 | 14.0% |
| 2 | 49714 | 13.6% |
| 4 | 27961 | 7.7% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 364748 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| Q | 182374 | |
| 3 | 53707 | 14.7% |
| 1 | 50992 | 14.0% |
| 2 | 49714 | 13.6% |
| 4 | 27961 | 7.7% |
Region
Categorical
MISSING
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 14357 |
| Missing (%) | 7.9% |
| Memory size | 2.8 MiB |
| West | |
|---|---|
| South | |
| North | |
| East | |
| NORTH |
Length
| Max length | 5 |
|---|---|
| Median length | 5 |
| Mean length | 4.5353446 |
| Min length | 4 |
Characters and Unicode
| Total characters | 762015 |
|---|---|
| Distinct characters | 16 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | NORTH |
|---|---|
| 2nd row | NORTH |
| 3rd row | NORTH |
| 4th row | NORTH |
| 5th row | NORTH |
Common Values
| Value | Count | Frequency (%) |
| West | 46309 | |
| South | 39364 | |
| North | 34229 | |
| East | 31761 | |
| NORTH | 16354 | 9.0% |
| (Missing) | 14357 | 7.9% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| north | 50583 | |
| west | 46309 | |
| south | 39364 | |
| east | 31761 |
Most occurring characters
| Value | Count | Frequency (%) |
| t | 151663 | |
| s | 78070 | |
| o | 73593 | |
| h | 73593 | |
| N | 50583 | 6.6% |
| W | 46309 | 6.1% |
| e | 46309 | 6.1% |
| S | 39364 | 5.2% |
| u | 39364 | 5.2% |
| r | 34229 | 4.5% |
| Other values (6) | 128938 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 762015 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| t | 151663 | |
| s | 78070 | |
| o | 73593 | |
| h | 73593 | |
| N | 50583 | 6.6% |
| W | 46309 | 6.1% |
| e | 46309 | 6.1% |
| S | 39364 | 5.2% |
| u | 39364 | 5.2% |
| r | 34229 | 4.5% |
| Other values (6) | 128938 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 762015 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| t | 151663 | |
| s | 78070 | |
| o | 73593 | |
| h | 73593 | |
| N | 50583 | 6.6% |
| W | 46309 | 6.1% |
| e | 46309 | 6.1% |
| S | 39364 | 5.2% |
| u | 39364 | 5.2% |
| r | 34229 | 4.5% |
| Other values (6) | 128938 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 762015 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| t | 151663 | |
| s | 78070 | |
| o | 73593 | |
| h | 73593 | |
| N | 50583 | 6.6% |
| W | 46309 | 6.1% |
| e | 46309 | 6.1% |
| S | 39364 | 5.2% |
| u | 39364 | 5.2% |
| r | 34229 | 4.5% |
| Other values (6) | 128938 |
Invoice Date
Date
| Distinct | 335 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.8 MiB |
| Minimum | 2023-04-01 00:00:00 |
|---|---|
| Maximum | 2024-02-29 00:00:00 |
Histogram with fixed size bins (bins=50)
Material
Text
| Distinct | 157 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.8 MiB |
Length
| Max length | 10 |
|---|---|
| Median length | 9 |
| Mean length | 8.5359865 |
| Min length | 7 |
Characters and Unicode
| Total characters | 1556742 |
|---|---|
| Distinct characters | 25 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 11 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | NFFW14PH1 |
|---|---|
| 2nd row | NEFM14PK1 |
| 3rd row | FM20PC1 |
| 4th row | FM20PC1 |
| 5th row | NEFM02PFC |
| Value | Count | Frequency (%) |
| nffm01pgc | 8973 | 4.9% |
| nffm01cl2 | 7998 | 4.4% |
| nfm01dq1 | 7402 | 4.1% |
| nffw01cl2 | 6436 | 3.5% |
| nffw02pfc | 6410 | 3.5% |
| nefw11pd1 | 6071 | 3.3% |
| nfw01dq1 | 5255 | 2.9% |
| ngfm08pc1 | 4943 | 2.7% |
| nefm11pd1 | 4879 | 2.7% |
| nfm05dq1 | 4744 | 2.6% |
| Other values (147) | 119263 |
Most occurring characters
| Value | Count | Frequency (%) |
| F | 296841 | |
| 1 | 213573 | |
| N | 154510 | |
| P | 133004 | |
| 0 | 126868 | |
| M | 96710 | 6.2% |
| W | 77677 | 5.0% |
| D | 72884 | 4.7% |
| C | 71983 | 4.6% |
| 2 | 67987 | 4.4% |
| Other values (15) | 244705 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1556742 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| F | 296841 | |
| 1 | 213573 | |
| N | 154510 | |
| P | 133004 | |
| 0 | 126868 | |
| M | 96710 | 6.2% |
| W | 77677 | 5.0% |
| D | 72884 | 4.7% |
| C | 71983 | 4.6% |
| 2 | 67987 | 4.4% |
| Other values (15) | 244705 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1556742 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| F | 296841 | |
| 1 | 213573 | |
| N | 154510 | |
| P | 133004 | |
| 0 | 126868 | |
| M | 96710 | 6.2% |
| W | 77677 | 5.0% |
| D | 72884 | 4.7% |
| C | 71983 | 4.6% |
| 2 | 67987 | 4.4% |
| Other values (15) | 244705 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1556742 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| F | 296841 | |
| 1 | 213573 | |
| N | 154510 | |
| P | 133004 | |
| 0 | 126868 | |
| M | 96710 | 6.2% |
| W | 77677 | 5.0% |
| D | 72884 | 4.7% |
| C | 71983 | 4.6% |
| 2 | 67987 | 4.4% |
| Other values (15) | 244705 |
Quantity
Real number (ℝ)
SKEWED
| Distinct | 53 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.1745808 |
| Minimum | -3 |
|---|---|
| Maximum | 89 |
| Zeros | 186 |
| Zeros (%) | 0.1% |
| Negative | 534 |
| Negative (%) | 0.3% |
| Memory size | 2.8 MiB |
Quantile statistics
| Minimum | -3 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 1 |
| 95-th percentile | 2 |
| Maximum | 89 |
| Range | 92 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.96682288 |
|---|---|
| Coefficient of variation (CV) | 0.82312164 |
| Kurtosis | 1140.7285 |
| Mean | 1.1745808 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 24.456273 |
| Sum | 214213 |
| Variance | 0.93474649 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1 | 160918 | |
| 2 | 16004 | 8.8% |
| 3 | 2877 | 1.6% |
| 4 | 816 | 0.4% |
| -1 | 518 | 0.3% |
| 5 | 328 | 0.2% |
| 0 | 186 | 0.1% |
| 6 | 178 | 0.1% |
| 7 | 99 | 0.1% |
| 8 | 72 | < 0.1% |
| Other values (43) | 378 | 0.2% |
| Value | Count | Frequency (%) |
| -3 | 2 | < 0.1% |
| -2 | 14 | < 0.1% |
| -1 | 518 | 0.3% |
| 0 | 186 | 0.1% |
| 1 | 160918 | |
| 2 | 16004 | 8.8% |
| 3 | 2877 | 1.6% |
| 4 | 816 | 0.4% |
| 5 | 328 | 0.2% |
| 6 | 178 | 0.1% |
| Value | Count | Frequency (%) |
| 89 | 1 | |
| 66 | 1 | |
| 60 | 1 | |
| 58 | 1 | |
| 57 | 1 | |
| 52 | 1 | |
| 49 | 2 | |
| 45 | 1 | |
| 44 | 1 | |
| 42 | 1 |
Gender
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.8 MiB |
| G | |
|---|---|
| L | |
| P | 8174 |
| U | 340 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 182374 |
|---|---|
| Distinct characters | 4 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | L |
|---|---|
| 2nd row | G |
| 3rd row | L |
| 4th row | L |
| 5th row | G |
Common Values
| Value | Count | Frequency (%) |
| G | 102230 | |
| L | 71630 | |
| P | 8174 | 4.5% |
| U | 340 | 0.2% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| g | 102230 | |
| l | 71630 | |
| p | 8174 | 4.5% |
| u | 340 | 0.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| G | 102230 | |
| L | 71630 | |
| P | 8174 | 4.5% |
| U | 340 | 0.2% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 182374 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| G | 102230 | |
| L | 71630 | |
| P | 8174 | 4.5% |
| U | 340 | 0.2% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 182374 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| G | 102230 | |
| L | 71630 | |
| P | 8174 | 4.5% |
| U | 340 | 0.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 182374 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| G | 102230 | |
| L | 71630 | |
| P | 8174 | 4.5% |
| U | 340 | 0.2% |
Brand
Categorical
IMBALANCE
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.8 MiB |
| TF | |
|---|---|
| Tf | 2520 |
| FP | 345 |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Characters and Unicode
| Total characters | 364748 |
|---|---|
| Distinct characters | 4 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | TF |
|---|---|
| 2nd row | TF |
| 3rd row | TF |
| 4th row | TF |
| 5th row | TF |
Common Values
| Value | Count | Frequency (%) |
| TF | 179509 | |
| Tf | 2520 | 1.4% |
| FP | 345 | 0.2% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| tf | 182029 | |
| fp | 345 | 0.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| T | 182029 | |
| F | 179854 | |
| f | 2520 | 0.7% |
| P | 345 | 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 364748 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| T | 182029 | |
| F | 179854 | |
| f | 2520 | 0.7% |
| P | 345 | 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 364748 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| T | 182029 | |
| F | 179854 | |
| f | 2520 | 0.7% |
| P | 345 | 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 364748 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| T | 182029 | |
| F | 179854 | |
| f | 2520 | 0.7% |
| P | 345 | 0.1% |
Channel
Categorical
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.8 MiB |
| SS | |
|---|---|
| LS | |
| PT | |
| CT | 7917 |
| LL | 655 |
| Other values (2) | 110 |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Characters and Unicode
| Total characters | 364748 |
|---|---|
| Distinct characters | 8 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | SS |
|---|---|
| 2nd row | SS |
| 3rd row | SS |
| 4th row | SS |
| 5th row | SS |
Common Values
| Value | Count | Frequency (%) |
| SS | 88915 | |
| LS | 70208 | |
| PT | 14569 | 8.0% |
| CT | 7917 | 4.3% |
| LL | 655 | 0.4% |
| AZ | 69 | < 0.1% |
| ss | 41 | < 0.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| ss | 88956 | |
| ls | 70208 | |
| pt | 14569 | 8.0% |
| ct | 7917 | 4.3% |
| ll | 655 | 0.4% |
| az | 69 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| S | 248038 | |
| L | 71518 | 19.6% |
| T | 22486 | 6.2% |
| P | 14569 | 4.0% |
| C | 7917 | 2.2% |
| s | 82 | < 0.1% |
| A | 69 | < 0.1% |
| Z | 69 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 364748 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| S | 248038 | |
| L | 71518 | 19.6% |
| T | 22486 | 6.2% |
| P | 14569 | 4.0% |
| C | 7917 | 2.2% |
| s | 82 | < 0.1% |
| A | 69 | < 0.1% |
| Z | 69 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 364748 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| S | 248038 | |
| L | 71518 | 19.6% |
| T | 22486 | 6.2% |
| P | 14569 | 4.0% |
| C | 7917 | 2.2% |
| s | 82 | < 0.1% |
| A | 69 | < 0.1% |
| Z | 69 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 364748 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| S | 248038 | |
| L | 71518 | 19.6% |
| T | 22486 | 6.2% |
| P | 14569 | 4.0% |
| C | 7917 | 2.2% |
| s | 82 | < 0.1% |
| A | 69 | < 0.1% |
| Z | 69 | < 0.1% |
Franchisee store
Text
MISSING
| Distinct | 342 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 18119 |
| Missing (%) | 9.9% |
| Memory size | 2.8 MiB |
Length
| Max length | 6 |
|---|---|
| Median length | 5 |
| Mean length | 5.1256217 |
| Min length | 5 |
Characters and Unicode
| Total characters | 841909 |
|---|---|
| Distinct characters | 18 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 4 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | SS241 |
|---|---|
| 2nd row | SS241 |
| 3rd row | SS241 |
| 4th row | SS241 |
| 5th row | SS241 |
| Value | Count | Frequency (%) |
| ss222 | 3554 | 2.2% |
| ss223 | 3194 | 1.9% |
| ls751 | 2957 | 1.8% |
| ls760 | 2599 | 1.6% |
| ss255 | 2214 | 1.3% |
| ss283 | 2151 | 1.3% |
| ss310 | 1848 | 1.1% |
| ss225 | 1816 | 1.1% |
| ls741 | 1786 | 1.1% |
| ss261 | 1781 | 1.1% |
| Other values (332) | 140355 |
Most occurring characters
| Value | Count | Frequency (%) |
| S | 223133 | |
| 2 | 103464 | |
| 7 | 80378 | 9.5% |
| 3 | 68802 | 8.2% |
| L | 63314 | 7.5% |
| 1 | 62614 | 7.4% |
| 0 | 53269 | 6.3% |
| 4 | 32523 | 3.9% |
| 8 | 31305 | 3.7% |
| 5 | 30782 | 3.7% |
| Other values (8) | 92325 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 841909 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| S | 223133 | |
| 2 | 103464 | |
| 7 | 80378 | 9.5% |
| 3 | 68802 | 8.2% |
| L | 63314 | 7.5% |
| 1 | 62614 | 7.4% |
| 0 | 53269 | 6.3% |
| 4 | 32523 | 3.9% |
| 8 | 31305 | 3.7% |
| 5 | 30782 | 3.7% |
| Other values (8) | 92325 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 841909 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| S | 223133 | |
| 2 | 103464 | |
| 7 | 80378 | 9.5% |
| 3 | 68802 | 8.2% |
| L | 63314 | 7.5% |
| 1 | 62614 | 7.4% |
| 0 | 53269 | 6.3% |
| 4 | 32523 | 3.9% |
| 8 | 31305 | 3.7% |
| 5 | 30782 | 3.7% |
| Other values (8) | 92325 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 841909 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| S | 223133 | |
| 2 | 103464 | |
| 7 | 80378 | 9.5% |
| 3 | 68802 | 8.2% |
| L | 63314 | 7.5% |
| 1 | 62614 | 7.4% |
| 0 | 53269 | 6.3% |
| 4 | 32523 | 3.9% |
| 8 | 31305 | 3.7% |
| 5 | 30782 | 3.7% |
| Other values (8) | 92325 |
| Distinct | 342 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.8 MiB |
Length
| Max length | 6 |
|---|---|
| Median length | 5 |
| Mean length | 5.1232906 |
| Min length | 5 |
Characters and Unicode
| Total characters | 934355 |
|---|---|
| Distinct characters | 18 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 4 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | SS241 |
|---|---|
| 2nd row | SS241 |
| 3rd row | SS241 |
| 4th row | SS241 |
| 5th row | SS241 |
| Value | Count | Frequency (%) |
| ss222 | 3958 | 2.2% |
| ss223 | 3527 | 1.9% |
| ls751 | 3301 | 1.8% |
| ls760 | 2879 | 1.6% |
| ss255 | 2446 | 1.3% |
| ss283 | 2385 | 1.3% |
| ss310 | 2025 | 1.1% |
| ls741 | 2013 | 1.1% |
| ss225 | 2002 | 1.1% |
| ss261 | 1988 | 1.1% |
| Other values (332) | 155850 |
Most occurring characters
| Value | Count | Frequency (%) |
| S | 248120 | |
| 2 | 114765 | |
| 7 | 89766 | 9.6% |
| 3 | 76186 | 8.2% |
| L | 70863 | 7.6% |
| 1 | 69020 | 7.4% |
| 0 | 59289 | 6.3% |
| 4 | 35638 | 3.8% |
| 8 | 34951 | 3.7% |
| 5 | 33960 | 3.6% |
| Other values (8) | 101797 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 934355 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| S | 248120 | |
| 2 | 114765 | |
| 7 | 89766 | 9.6% |
| 3 | 76186 | 8.2% |
| L | 70863 | 7.6% |
| 1 | 69020 | 7.4% |
| 0 | 59289 | 6.3% |
| 4 | 35638 | 3.8% |
| 8 | 34951 | 3.7% |
| 5 | 33960 | 3.6% |
| Other values (8) | 101797 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 934355 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| S | 248120 | |
| 2 | 114765 | |
| 7 | 89766 | 9.6% |
| 3 | 76186 | 8.2% |
| L | 70863 | 7.6% |
| 1 | 69020 | 7.4% |
| 0 | 59289 | 6.3% |
| 4 | 35638 | 3.8% |
| 8 | 34951 | 3.7% |
| 5 | 33960 | 3.6% |
| Other values (8) | 101797 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 934355 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| S | 248120 | |
| 2 | 114765 | |
| 7 | 89766 | 9.6% |
| 3 | 76186 | 8.2% |
| L | 70863 | 7.6% |
| 1 | 69020 | 7.4% |
| 0 | 59289 | 6.3% |
| 4 | 35638 | 3.8% |
| 8 | 34951 | 3.7% |
| 5 | 33960 | 3.6% |
| Other values (8) | 101797 |
| Distinct | 339 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.8 MiB |
Length
| Max length | 42 |
|---|---|
| Median length | 34 |
| Mean length | 21.517234 |
| Min length | 9 |
Characters and Unicode
| Total characters | 3924184 |
|---|---|
| Distinct characters | 70 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 3 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | 158-SSL-VIJAYWADA |
|---|---|
| 2nd row | 158-SSL-VIJAYWADA |
| 3rd row | 158-SSL-VIJAYWADA |
| 4th row | 158-SSL-VIJAYWADA |
| 5th row | 158-SSL-VIJAYWADA |
| Value | Count | Frequency (%) |
| 29582 | 6.5% | |
| city | 16315 | 3.6% |
| mall | 13735 | 3.0% |
| kolkata | 13026 | 2.9% |
| ls | 8784 | 1.9% |
| market | 7650 | 1.7% |
| phoenix | 6813 | 1.5% |
| pune | 5192 | 1.1% |
| center | 4519 | 1.0% |
| lake | 4275 | 0.9% |
| Other values (608) | 343989 |
Most occurring characters
| Value | Count | Frequency (%) |
| - | 306304 | 7.8% |
| 270524 | 6.9% | |
| S | 269350 | 6.9% |
| A | 248796 | 6.3% |
| L | 232503 | 5.9% |
| a | 169490 | 4.3% |
| T | 128762 | 3.3% |
| R | 113002 | 2.9% |
| I | 97571 | 2.5% |
| O | 96572 | 2.5% |
| Other values (60) | 1991310 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 3924184 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| - | 306304 | 7.8% |
| 270524 | 6.9% | |
| S | 269350 | 6.9% |
| A | 248796 | 6.3% |
| L | 232503 | 5.9% |
| a | 169490 | 4.3% |
| T | 128762 | 3.3% |
| R | 113002 | 2.9% |
| I | 97571 | 2.5% |
| O | 96572 | 2.5% |
| Other values (60) | 1991310 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 3924184 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| - | 306304 | 7.8% |
| 270524 | 6.9% | |
| S | 269350 | 6.9% |
| A | 248796 | 6.3% |
| L | 232503 | 5.9% |
| a | 169490 | 4.3% |
| T | 128762 | 3.3% |
| R | 113002 | 2.9% |
| I | 97571 | 2.5% |
| O | 96572 | 2.5% |
| Other values (60) | 1991310 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 3924184 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| - | 306304 | 7.8% |
| 270524 | 6.9% | |
| S | 269350 | 6.9% |
| A | 248796 | 6.3% |
| L | 232503 | 5.9% |
| a | 169490 | 4.3% |
| T | 128762 | 3.3% |
| R | 113002 | 2.9% |
| I | 97571 | 2.5% |
| O | 96572 | 2.5% |
| Other values (60) | 1991310 |
MRP
Real number (ℝ)
| Distinct | 35 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1731.4531 |
| Minimum | 395 |
|---|---|
| Maximum | 4995 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.8 MiB |
Quantile statistics
| Minimum | 395 |
|---|---|
| 5-th percentile | 499 |
| Q1 | 645 |
| median | 1895 |
| Q3 | 2595 |
| 95-th percentile | 3095 |
| Maximum | 4995 |
| Range | 4600 |
| Interquartile range (IQR) | 1950 |
Descriptive statistics
| Standard deviation | 1017.3611 |
|---|---|
| Coefficient of variation (CV) | 0.58757646 |
| Kurtosis | -0.68494272 |
| Mean | 1731.4531 |
| Median Absolute Deviation (MAD) | 800 |
| Skewness | 0.32184595 |
| Sum | 3.1577202 × 108 |
| Variance | 1035023.5 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=35)
| Value | Count | Frequency (%) |
| 499 | 35794 | |
| 2595 | 28765 | |
| 645 | 23548 | |
| 1995 | 22879 | |
| 1895 | 13454 | 7.4% |
| 1595 | 10716 | 5.9% |
| 2695 | 9727 | 5.3% |
| 3995 | 6525 | 3.6% |
| 1295 | 6392 | 3.5% |
| 3095 | 4997 | 2.7% |
| Other values (25) | 19577 |
| Value | Count | Frequency (%) |
| 395 | 515 | 0.3% |
| 399 | 12 | < 0.1% |
| 499 | 35794 | |
| 545 | 108 | 0.1% |
| 595 | 406 | 0.2% |
| 645 | 23548 | |
| 845 | 2592 | 1.4% |
| 895 | 355 | 0.2% |
| 995 | 2661 | 1.5% |
| 1195 | 5 | < 0.1% |
| Value | Count | Frequency (%) |
| 4995 | 282 | 0.2% |
| 4795 | 587 | 0.3% |
| 4590 | 206 | 0.1% |
| 4190 | 41 | < 0.1% |
| 3995 | 6525 | |
| 3095 | 4997 | |
| 2995 | 4554 | |
| 2895 | 1270 | 0.7% |
| 2795 | 4186 | |
| 2695 | 9727 |
Gross UCP
Real number (ℝ)
| Distinct | 266 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2024.9683 |
| Minimum | -7785 |
|---|---|
| Maximum | 177555 |
| Zeros | 186 |
| Zeros (%) | 0.1% |
| Negative | 534 |
| Negative (%) | 0.3% |
| Memory size | 2.8 MiB |
Quantile statistics
| Minimum | -7785 |
|---|---|
| 5-th percentile | 499 |
| Q1 | 645 |
| median | 1895 |
| Q3 | 2595 |
| 95-th percentile | 4785 |
| Maximum | 177555 |
| Range | 185340 |
| Interquartile range (IQR) | 1950 |
Descriptive statistics
| Standard deviation | 2048.1348 |
|---|---|
| Coefficient of variation (CV) | 1.0114405 |
| Kurtosis | 626.55447 |
| Mean | 2024.9683 |
| Median Absolute Deviation (MAD) | 900 |
| Skewness | 14.545639 |
| Sum | 3.6930156 × 108 |
| Variance | 4194856.3 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 499 | 31814 | |
| 2595 | 25354 | |
| 645 | 21095 | |
| 1995 | 20185 | |
| 1895 | 11223 | 6.2% |
| 2695 | 8882 | 4.9% |
| 1595 | 8066 | 4.4% |
| 3995 | 5915 | 3.2% |
| 1295 | 5742 | 3.1% |
| 3095 | 4672 | 2.6% |
| Other values (256) | 39426 |
| Value | Count | Frequency (%) |
| -7785 | 1 | < 0.1% |
| -5590 | 1 | < 0.1% |
| -5190 | 1 | < 0.1% |
| -4995 | 1 | < 0.1% |
| -4990 | 1 | < 0.1% |
| -4795 | 2 | < 0.1% |
| -4785 | 1 | < 0.1% |
| -4590 | 1 | < 0.1% |
| -4190 | 1 | < 0.1% |
| -3995 | 37 |
| Value | Count | Frequency (%) |
| 177555 | 1 | |
| 119800 | 1 | |
| 105270 | 1 | |
| 95700 | 1 | |
| 92510 | 1 | |
| 90915 | 1 | |
| 87780 | 1 | |
| 82940 | 1 | |
| 78155 | 2 | |
| 71775 | 1 |
Net UCP
Real number (ℝ)
| Distinct | 7439 |
|---|---|
| Distinct (%) | 4.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1805.9932 |
| Minimum | -6785 |
|---|---|
| Maximum | 125705.09 |
| Zeros | 447 |
| Zeros (%) | 0.2% |
| Negative | 543 |
| Negative (%) | 0.3% |
| Memory size | 2.8 MiB |
Quantile statistics
| Minimum | -6785 |
|---|---|
| 5-th percentile | 499 |
| Q1 | 645 |
| median | 1795.5 |
| Q3 | 2545.75 |
| 95-th percentile | 3995 |
| Maximum | 125705.09 |
| Range | 132490.09 |
| Interquartile range (IQR) | 1900.75 |
Descriptive statistics
| Standard deviation | 1569.9259 |
|---|---|
| Coefficient of variation (CV) | 0.86928669 |
| Kurtosis | 433.99923 |
| Mean | 1805.9932 |
| Median Absolute Deviation (MAD) | 800.5 |
| Skewness | 10.284241 |
| Sum | 3.2936621 × 108 |
| Variance | 2464667.2 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 499 | 26774 | 14.7% |
| 645 | 16756 | 9.2% |
| 2595 | 12055 | 6.6% |
| 1995 | 11151 | 6.1% |
| 1795.5 | 5758 | 3.2% |
| 1895 | 5741 | 3.1% |
| 1295 | 5342 | 2.9% |
| 2695 | 4322 | 2.4% |
| 2335.5 | 4279 | 2.3% |
| 1595 | 3147 | 1.7% |
| Other values (7429) | 87049 |
| Value | Count | Frequency (%) |
| -6785 | 1 | < 0.1% |
| -6380 | 1 | < 0.1% |
| -5190 | 1 | < 0.1% |
| -4590 | 1 | < 0.1% |
| -4495 | 1 | < 0.1% |
| -4241.5 | 1 | < 0.1% |
| -4000 | 1 | < 0.1% |
| -3995 | 20 | |
| -3836 | 2 | < 0.1% |
| -3690 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 125705.09 | 1 | |
| 99800 | 1 | |
| 73381 | 1 | |
| 65934 | 1 | |
| 59940 | 1 | |
| 57942 | 1 | |
| 56862.07 | 1 | |
| 52242.03 | 1 | |
| 48725.9 | 1 | |
| 48693.79 | 1 |
| Distinct | 139 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.8 MiB |
Length
| Max length | 18 |
|---|---|
| Median length | 11 |
| Mean length | 6.925077 |
| Min length | 3 |
Characters and Unicode
| Total characters | 1262954 |
|---|---|
| Distinct characters | 48 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | VIJAYAWADA |
|---|---|
| 2nd row | VIJAYAWADA |
| 3rd row | VIJAYAWADA |
| 4th row | VIJAYAWADA |
| 5th row | VIJAYAWADA |
| Value | Count | Frequency (%) |
| kolkata | 22552 | 12.3% |
| mumbai | 22055 | 12.0% |
| bangalore | 19210 | 10.5% |
| pune | 12133 | 6.6% |
| delhi | 11455 | 6.2% |
| hyderabad | 9860 | 5.4% |
| noida | 7457 | 4.1% |
| chennai | 5585 | 3.0% |
| lucknow | 3978 | 2.2% |
| bhubaneswar | 3793 | 2.1% |
| Other values (85) | 65286 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 222046 | |
| o | 72862 | 5.8% |
| e | 72847 | 5.8% |
| i | 71512 | 5.7% |
| n | 70419 | 5.6% |
| r | 70247 | 5.6% |
| u | 67066 | 5.3% |
| l | 61451 | 4.9% |
| d | 47145 | 3.7% |
| h | 43268 | 3.4% |
| Other values (38) | 464091 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1262954 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 222046 | |
| o | 72862 | 5.8% |
| e | 72847 | 5.8% |
| i | 71512 | 5.7% |
| n | 70419 | 5.6% |
| r | 70247 | 5.6% |
| u | 67066 | 5.3% |
| l | 61451 | 4.9% |
| d | 47145 | 3.7% |
| h | 43268 | 3.4% |
| Other values (38) | 464091 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1262954 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 222046 | |
| o | 72862 | 5.8% |
| e | 72847 | 5.8% |
| i | 71512 | 5.7% |
| n | 70419 | 5.6% |
| r | 70247 | 5.6% |
| u | 67066 | 5.3% |
| l | 61451 | 4.9% |
| d | 47145 | 3.7% |
| h | 43268 | 3.4% |
| Other values (38) | 464091 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1262954 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 222046 | |
| o | 72862 | 5.8% |
| e | 72847 | 5.8% |
| i | 71512 | 5.7% |
| n | 70419 | 5.6% |
| r | 70247 | 5.6% |
| u | 67066 | 5.3% |
| l | 61451 | 4.9% |
| d | 47145 | 3.7% |
| h | 43268 | 3.4% |
| Other values (38) | 464091 |
ShiptopartyStateCode
Categorical
| Distinct | 37 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.8 MiB |
| MAHARASTRA | |
|---|---|
| KARNATAKA | |
| WEST BENGAL | |
| DELHI | |
| UTTAR PRADESH | |
| Other values (32) |
Length
| Max length | 17 |
|---|---|
| Median length | 15 |
| Mean length | 9.362623 |
| Min length | 3 |
Characters and Unicode
| Total characters | 1707499 |
|---|---|
| Distinct characters | 39 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | ANDHRA PRADESH |
|---|---|
| 2nd row | ANDHRA PRADESH |
| 3rd row | ANDHRA PRADESH |
| 4th row | ANDHRA PRADESH |
| 5th row | ANDHRA PRADESH |
Common Values
| Value | Count | Frequency (%) |
| MAHARASTRA | 39645 | |
| KARNATAKA | 22044 | |
| WEST BENGAL | 19783 | |
| DELHI | 12535 | 6.9% |
| UTTAR PRADESH | 11321 | 6.2% |
| WESTBENGAL | 8276 | 4.5% |
| GUJARAT | 8062 | 4.4% |
| Telangana | 7312 | 4.0% |
| HARYANA | 6206 | 3.4% |
| TAMIL NADU | 5530 | 3.0% |
| Other values (27) | 41660 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| maharastra | 39645 | |
| karnataka | 22044 | 9.7% |
| west | 19783 | 8.7% |
| bengal | 19783 | 8.7% |
| pradesh | 18637 | 8.2% |
| delhi | 12535 | 5.5% |
| uttar | 11321 | 5.0% |
| telangana | 9886 | 4.4% |
| westbengal | 8276 | 3.6% |
| gujarat | 8062 | 3.6% |
| Other values (26) | 56938 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 424038 | |
| R | 173187 | |
| T | 154675 | 9.1% |
| S | 108254 | 6.3% |
| H | 104923 | 6.1% |
| E | 96943 | 5.7% |
| N | 79936 | 4.7% |
| M | 57695 | 3.4% |
| D | 56187 | 3.3% |
| L | 52025 | 3.0% |
| Other values (29) | 399636 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1707499 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| A | 424038 | |
| R | 173187 | |
| T | 154675 | 9.1% |
| S | 108254 | 6.3% |
| H | 104923 | 6.1% |
| E | 96943 | 5.7% |
| N | 79936 | 4.7% |
| M | 57695 | 3.4% |
| D | 56187 | 3.3% |
| L | 52025 | 3.0% |
| Other values (29) | 399636 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1707499 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| A | 424038 | |
| R | 173187 | |
| T | 154675 | 9.1% |
| S | 108254 | 6.3% |
| H | 104923 | 6.1% |
| E | 96943 | 5.7% |
| N | 79936 | 4.7% |
| M | 57695 | 3.4% |
| D | 56187 | 3.3% |
| L | 52025 | 3.0% |
| Other values (29) | 399636 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1707499 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| A | 424038 | |
| R | 173187 | |
| T | 154675 | 9.1% |
| S | 108254 | 6.3% |
| H | 104923 | 6.1% |
| E | 96943 | 5.7% |
| N | 79936 | 4.7% |
| M | 57695 | 3.4% |
| D | 56187 | 3.3% |
| L | 52025 | 3.0% |
| Other values (29) | 399636 |
Channel-2
Categorical
CONSTANT
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.8 MiB |
| LFS |
|---|
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 547122 |
|---|---|
| Distinct characters | 3 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | LFS |
|---|---|
| 2nd row | LFS |
| 3rd row | LFS |
| 4th row | LFS |
| 5th row | LFS |
Common Values
| Value | Count | Frequency (%) |
| LFS | 182374 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| lfs | 182374 |
Most occurring characters
| Value | Count | Frequency (%) |
| L | 182374 | |
| F | 182374 | |
| S | 182374 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 547122 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| L | 182374 | |
| F | 182374 | |
| S | 182374 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 547122 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| L | 182374 | |
| F | 182374 | |
| S | 182374 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 547122 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| L | 182374 | |
| F | 182374 | |
| S | 182374 |
Billing grp
Categorical
CONSTANT
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.8 MiB |
| LFS |
|---|
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 547122 |
|---|---|
| Distinct characters | 3 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | LFS |
|---|---|
| 2nd row | LFS |
| 3rd row | LFS |
| 4th row | LFS |
| 5th row | LFS |
Common Values
| Value | Count | Frequency (%) |
| LFS | 182374 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| lfs | 182374 |
Most occurring characters
| Value | Count | Frequency (%) |
| L | 182374 | |
| F | 182374 | |
| S | 182374 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 547122 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| L | 182374 | |
| F | 182374 | |
| S | 182374 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 547122 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| L | 182374 | |
| F | 182374 | |
| S | 182374 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 547122 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| L | 182374 | |
| F | 182374 | |
| S | 182374 |
Varient Name2
Text
| Distinct | 78 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.8 MiB |
Length
| Max length | 52 |
|---|---|
| Median length | 38 |
| Mean length | 15.799769 |
| Min length | 8 |
Characters and Unicode
| Total characters | 2881467 |
|---|---|
| Distinct characters | 62 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 3 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Aqua W 30 ml |
|---|---|
| 2nd row | Aqua M 90 ml |
| 3rd row | Tales M Rio 100 ml |
| 4th row | Tales M Rio 100 ml |
| 5th row | 100 M Steele |
| Value | Count | Frequency (%) |
| m | 95117 | 12.4% |
| w | 73947 | 9.7% |
| deo | 57025 | 7.5% |
| ml | 55172 | 7.2% |
| 100 | 53526 | 7.0% |
| 150 | 35806 | 4.7% |
| raw | 31772 | 4.2% |
| 20 | 29309 | 3.8% |
| celeste | 26988 | 3.5% |
| 50 | 18549 | 2.4% |
| Other values (97) | 287121 |
Most occurring characters
| Value | Count | Frequency (%) |
| 582335 | ||
| e | 284005 | 9.9% |
| 0 | 211370 | 7.3% |
| l | 130246 | 4.5% |
| o | 129906 | 4.5% |
| M | 118408 | 4.1% |
| 1 | 96344 | 3.3% |
| a | 89006 | 3.1% |
| W | 79242 | 2.8% |
| m | 77316 | 2.7% |
| Other values (52) | 1083289 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 2881467 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 582335 | ||
| e | 284005 | 9.9% |
| 0 | 211370 | 7.3% |
| l | 130246 | 4.5% |
| o | 129906 | 4.5% |
| M | 118408 | 4.1% |
| 1 | 96344 | 3.3% |
| a | 89006 | 3.1% |
| W | 79242 | 2.8% |
| m | 77316 | 2.7% |
| Other values (52) | 1083289 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 2881467 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 582335 | ||
| e | 284005 | 9.9% |
| 0 | 211370 | 7.3% |
| l | 130246 | 4.5% |
| o | 129906 | 4.5% |
| M | 118408 | 4.1% |
| 1 | 96344 | 3.3% |
| a | 89006 | 3.1% |
| W | 79242 | 2.8% |
| m | 77316 | 2.7% |
| Other values (52) | 1083289 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 2881467 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 582335 | ||
| e | 284005 | 9.9% |
| 0 | 211370 | 7.3% |
| l | 130246 | 4.5% |
| o | 129906 | 4.5% |
| M | 118408 | 4.1% |
| 1 | 96344 | 3.3% |
| a | 89006 | 3.1% |
| W | 79242 | 2.8% |
| m | 77316 | 2.7% |
| Other values (52) | 1083289 |
Collection
Categorical
| Distinct | 18 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.8 MiB |
| Gift Pack | |
|---|---|
| Classic 100 ml | |
| Premium Deo | |
| Classic 20 ml | |
| Classic 50 ml | |
| Other values (13) |
Length
| Max length | 16 |
|---|---|
| Median length | 14 |
| Mean length | 11.373589 |
| Min length | 4 |
Characters and Unicode
| Total characters | 2074247 |
|---|---|
| Distinct characters | 37 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Aqua |
|---|---|
| 2nd row | Aqua |
| 3rd row | Tales 100ml |
| 4th row | Tales 100ml |
| 5th row | Classic 100 ml |
Common Values
| Value | Count | Frequency (%) |
| Gift Pack | 29563 | |
| Classic 100 ml | 29340 | |
| Premium Deo | 25533 | |
| Classic 20 ml | 24062 | |
| Classic 50 ml | 13982 | |
| Aqua | 12519 | |
| Escapade Deo | 10273 | 5.6% |
| Escapade | 9795 | 5.4% |
| Nox 100 ml | 6525 | 3.6% |
| Deo Bundle Pack | 6384 | 3.5% |
| Other values (8) | 14398 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| ml | 79156 | |
| classic | 68654 | |
| deo | 42190 | |
| pack | 35947 | |
| 100 | 35865 | |
| gift | 29563 | 6.8% |
| 20 | 29309 | 6.8% |
| premium | 25533 | 5.9% |
| escapade | 20068 | 4.6% |
| 50 | 13982 | 3.2% |
| Other values (12) | 52356 |
Most occurring characters
| Value | Count | Frequency (%) |
| 292441 | ||
| a | 169324 | 8.2% |
| l | 165503 | 8.0% |
| s | 160258 | 7.7% |
| m | 137742 | 6.6% |
| 0 | 130057 | 6.3% |
| c | 125015 | 6.0% |
| i | 123782 | 6.0% |
| e | 97968 | 4.7% |
| C | 68654 | 3.3% |
| Other values (27) | 603503 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 2074247 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 292441 | ||
| a | 169324 | 8.2% |
| l | 165503 | 8.0% |
| s | 160258 | 7.7% |
| m | 137742 | 6.6% |
| 0 | 130057 | 6.3% |
| c | 125015 | 6.0% |
| i | 123782 | 6.0% |
| e | 97968 | 4.7% |
| C | 68654 | 3.3% |
| Other values (27) | 603503 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 2074247 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 292441 | ||
| a | 169324 | 8.2% |
| l | 165503 | 8.0% |
| s | 160258 | 7.7% |
| m | 137742 | 6.6% |
| 0 | 130057 | 6.3% |
| c | 125015 | 6.0% |
| i | 123782 | 6.0% |
| e | 97968 | 4.7% |
| C | 68654 | 3.3% |
| Other values (27) | 603503 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 2074247 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 292441 | ||
| a | 169324 | 8.2% |
| l | 165503 | 8.0% |
| s | 160258 | 7.7% |
| m | 137742 | 6.6% |
| 0 | 130057 | 6.3% |
| c | 125015 | 6.0% |
| i | 123782 | 6.0% |
| e | 97968 | 4.7% |
| C | 68654 | 3.3% |
| Other values (27) | 603503 |
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.
| Year | Month | Month Key | QTR | Region | Invoice Date | Material | Quantity | Gender | Brand | Channel | Franchisee store | Bill to Party code | Bill to Party Name | MRP | Gross UCP | Net UCP | Bill to Party City | ShiptopartyStateCode | Channel-2 | Billing grp | Varient Name2 | Collection | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 42915 | 2023-24 | 2023-04-01 | Apr | Q1 | NORTH | 2023-04-20 00:00:00 | NFFW14PH1 | 2.0 | L | TF | SS | SS241 | SS241 | 158-SSL-VIJAYWADA | 1595 | 3190.0 | 3190.0 | VIJAYAWADA | ANDHRA PRADESH | LFS | LFS | Aqua W 30 ml | Aqua |
| 42916 | 2023-24 | 2023-04-01 | Apr | Q1 | NORTH | 2023-04-21 00:00:00 | NEFM14PK1 | 1.0 | G | TF | SS | SS241 | SS241 | 158-SSL-VIJAYWADA | 2495 | 2495.0 | 1995.0 | VIJAYAWADA | ANDHRA PRADESH | LFS | LFS | Aqua M 90 ml | Aqua |
| 42917 | 2023-24 | 2023-04-01 | Apr | Q1 | NORTH | 2023-04-20 00:00:00 | FM20PC1 | 1.0 | L | TF | SS | SS241 | SS241 | 158-SSL-VIJAYWADA | 1595 | 1595.0 | 1595.0 | VIJAYAWADA | ANDHRA PRADESH | LFS | LFS | Tales M Rio 100 ml | Tales 100ml |
| 42918 | 2023-24 | 2023-04-01 | Apr | Q1 | NORTH | 2023-04-27 00:00:00 | FM20PC1 | 1.0 | L | TF | SS | SS241 | SS241 | 158-SSL-VIJAYWADA | 1595 | 1595.0 | 1595.0 | VIJAYAWADA | ANDHRA PRADESH | LFS | LFS | Tales M Rio 100 ml | Tales 100ml |
| 42919 | 2023-24 | 2023-04-01 | Apr | Q1 | NORTH | 2023-04-22 00:00:00 | NEFM02PFC | 1.0 | G | TF | SS | SS241 | SS241 | 158-SSL-VIJAYWADA | 2295 | 2295.0 | 2295.0 | VIJAYAWADA | ANDHRA PRADESH | LFS | LFS | 100 M Steele | Classic 100 ml |
| 42920 | 2023-24 | 2023-04-01 | Apr | Q1 | NORTH | 2023-04-29 00:00:00 | FM19PC1 | 1.0 | L | TF | SS | SS241 | SS241 | 158-SSL-VIJAYWADA | 1595 | 1595.0 | 1595.0 | VIJAYAWADA | ANDHRA PRADESH | LFS | LFS | Tales M Oslo 100 ml | Tales 100ml |
| 42921 | 2023-24 | 2023-04-01 | Apr | Q1 | NORTH | 2023-04-26 00:00:00 | NFFM01PGC | 1.0 | G | TF | SS | SS241 | SS241 | 158-SSL-VIJAYWADA | 2595 | 2595.0 | 2595.0 | VIJAYAWADA | ANDHRA PRADESH | LFS | LFS | 100 M Raw | Classic 100 ml |
| 42922 | 2023-24 | 2023-04-01 | Apr | Q1 | NORTH | 2023-04-23 00:00:00 | NFFW04PFC | 1.0 | L | TF | SS | SS241 | SS241 | 158-SSL-VIJAYWADA | 2595 | 2595.0 | 2595.0 | VIJAYAWADA | ANDHRA PRADESH | LFS | LFS | 100 W Sheer | Classic 100 ml |
| 42923 | 2023-24 | 2023-04-01 | Apr | Q1 | NORTH | 2023-04-29 00:00:00 | NFFW05PG2 | 1.0 | L | TF | SS | SS241 | SS241 | 158-SSL-VIJAYWADA | 1995 | 1995.0 | 1995.0 | VIJAYAWADA | ANDHRA PRADESH | LFS | LFS | Mini 25 ml W (C,S) | Gift Pack |
| 42924 | 2023-24 | 2023-04-01 | Apr | Q1 | NORTH | 2023-04-28 00:00:00 | FW21PC1 | 1.0 | L | TF | SS | SS241 | SS241 | 158-SSL-VIJAYWADA | 3095 | 3095.0 | 3095.0 | VIJAYAWADA | ANDHRA PRADESH | LFS | LFS | Noura W Floret 100 ml | Noura W 100ml |
| Year | Month | Month Key | QTR | Region | Invoice Date | Material | Quantity | Gender | Brand | Channel | Franchisee store | Bill to Party code | Bill to Party Name | MRP | Gross UCP | Net UCP | Bill to Party City | ShiptopartyStateCode | Channel-2 | Billing grp | Varient Name2 | Collection | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 940522 | 2023-24 | 2023-02-01 | Feb | Q4 | East | 2024-02-05 00:00:00 | FW22PC1 | 1.0 | L | TF | SS | SS292 | SS292 | 312-SSL-RANCHI | 3095 | 3095.0 | 3095.00 | Ranchi | JHARKHAND | LFS | LFS | Noura W Iris 100 ml | Noura W 100ml |
| 940523 | 2023-24 | 2023-02-01 | Feb | Q4 | East | 2024-02-17 00:00:00 | FW22PC1 | 1.0 | L | TF | SS | SS292 | SS292 | 312-SSL-RANCHI | 3095 | 3095.0 | 3095.00 | Ranchi | JHARKHAND | LFS | LFS | Noura W Iris 100 ml | Noura W 100ml |
| 940524 | 2023-24 | 2023-02-01 | Feb | Q4 | East | 2024-02-08 00:00:00 | NFFW14PK1 | 1.0 | L | TF | SS | SS292 | SS292 | 312-SSL-RANCHI | 2795 | 2795.0 | 2795.00 | Ranchi | JHARKHAND | LFS | LFS | Aqua W 90 ml | Aqua |
| 940525 | 2023-24 | 2023-02-01 | Feb | Q4 | East | 2024-02-05 00:00:00 | NFFW03PFL | 1.0 | L | TF | SS | SS292 | SS292 | 312-SSL-RANCHI | 1895 | 1895.0 | 1895.00 | Ranchi | JHARKHAND | LFS | LFS | 50 W Nude | Classic 50 ml |
| 940526 | 2023-24 | 2023-02-01 | Feb | Q4 | East | 2024-02-15 00:00:00 | NFFW01CL2 | 1.0 | G | TF | SS | SS292 | SS292 | 312-SSL-RANCHI | 1995 | 1995.0 | 1995.00 | Ranchi | JHARKHAND | LFS | LFS | Coffret Deo W Celeste | Gift Pack |
| 940527 | 2023-24 | 2023-02-01 | Feb | Q4 | East | 2024-02-12 00:00:00 | NFFW01CL2 | 1.0 | G | TF | SS | SS292 | SS292 | 312-SSL-RANCHI | 1995 | 1995.0 | 1995.00 | Ranchi | JHARKHAND | LFS | LFS | Coffret Deo W Celeste | Gift Pack |
| 940528 | 2023-24 | 2023-02-01 | Feb | Q4 | East | 2024-02-05 00:00:00 | NFFM01PGL | 1.0 | G | TF | SS | SS292 | SS292 | 312-SSL-RANCHI | 1895 | 1895.0 | 1895.00 | Ranchi | JHARKHAND | LFS | LFS | 50 M Raw | Classic 50 ml |
| 940529 | 2023-24 | 2023-02-01 | Feb | Q4 | East | 2024-02-11 00:00:00 | NFFW03PFC | 1.0 | L | TF | SS | SS292 | SS292 | 312-SSL-RANCHI | 2595 | 2595.0 | 2122.32 | Ranchi | JHARKHAND | LFS | LFS | 100 W Nude | Classic 100 ml |
| 940530 | 2023-24 | 2023-02-01 | Feb | Q4 | East | 2024-02-21 00:00:00 | NGFM08PC1 | 1.0 | G | TF | SS | SS292 | SS292 | 312-SSL-RANCHI | 2695 | 2695.0 | 2695.00 | Ranchi | JHARKHAND | LFS | LFS | 100 M CRoad | Escapade |
| 940531 | 2023-24 | 2023-02-01 | Feb | Q4 | East | 2024-02-21 00:00:00 | NFFP01PG2 | 1.0 | P | TF | SS | SS292 | SS292 | 312-SSL-RANCHI | 1995 | 1995.0 | 1995.00 | Ranchi | JHARKHAND | LFS | LFS | His & Her Mini 25 ml (V,S) | Gift Pack |
Most frequently occurring
| Year | Month | Month Key | QTR | Region | Invoice Date | Material | Quantity | Gender | Brand | Channel | Franchisee store | Bill to Party code | Bill to Party Name | MRP | Gross UCP | Net UCP | Bill to Party City | ShiptopartyStateCode | Channel-2 | Billing grp | Varient Name2 | Collection | # duplicates | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 2023-24 | 2023-02-01 | Feb | Q4 | East | 2024-02-08 | NFFM01PGC | 1.0 | G | TF | SS | SS272 | SS272 | 257-SSL-CITY CENTER KOLKATA | 2595 | 2595.0 | 2595.0 | Kolkata | WEST BENGAL | LFS | LFS | 100 M Raw | Classic 100 ml | 2 |
| 1 | 2023-24 | 2023-02-01 | Feb | Q4 | East | 2024-02-22 | NFFP01PGFL | 1.0 | P | TF | SS | SS283 | SS283 | 188-SSL-ACROPOLIS KOLKATA | 2995 | 2995.0 | 2995.0 | Kolkata | WEST BENGAL | LFS | LFS | His & Her 50 ml (R,C) | Gift Pack | 2 |
| 2 | 2023-24 | 2023-02-01 | Feb | Q4 | East | 2024-02-22 | NFM03DQ1 | 1.0 | G | TF | SS | SS222 | SS222 | 115-SSL-SALT LAKE KOLKATA | 499 | 499.0 | 499.0 | Kolkata | WEST BENGAL | LFS | LFS | 150 M Amalfi Men deo | Premium Deo | 2 |
| 3 | 2023-24 | 2023-02-01 | Feb | Q4 | North | 2024-02-25 | NFFP01PG2 | 1.0 | P | TF | SS | SS220 | SS220 | 130-SSL-GIP NOIDA | 1995 | 1995.0 | 1995.0 | Noida | UTTAR PRADESH | LFS | LFS | His & Her Mini 25 ml (V,S) | Gift Pack | 2 |
| 4 | 2023-24 | 2023-02-01 | Feb | Q4 | West | 2024-02-09 | NFM01DQ1 | 1.0 | G | TF | SS | SS260 | SS260 | 177-SSL-KALYAN | 499 | 499.0 | 499.0 | Mumbai | MAHARASTRA | LFS | LFS | 150 M Raw Deo | Premium Deo | 2 |
| 5 | 2023-24 | 2023-02-01 | Feb | Q4 | West | 2024-02-09 | NFW01DQ1 | 1.0 | L | TF | SS | SS204 | SS204 | 101-SSL-ANDHERI | 499 | 499.0 | 499.0 | Mumbai | MAHARASTRA | LFS | LFS | 150 W Celeste Deo | Premium Deo | 2 |
| 6 | 2023-24 | 2023-02-01 | Feb | Q4 | West | 2024-02-17 | NFFW03PFC | 1.0 | L | TF | SS | SS290 | SS290 | 273-SSL-AUNDH PUNE | 2595 | 2595.0 | 2595.0 | Pune | MAHARASTRA | LFS | LFS | 100 W Nude | Classic 100 ml | 2 |
| 7 | 2023-24 | 2023-02-01 | Feb | Q4 | West | 2024-02-24 | NFM06DQ1 | 1.0 | G | TF | SS | SS261 | SS261 | 196-SSL-VADODARA | 499 | 499.0 | 499.0 | Baroda | GUJARAT | LFS | LFS | Deo M M Groove 150 ml | Escapade Deo | 2 |
| 8 | 2023-24 | 2023-04-01 | Apr | Q1 | NORTH | 2023-04-13 | NEFW13PD1 | 1.0 | L | TF | SS | SS283 | SS283 | 188-SSL-ACROPOLIS KOLKATA | 645 | 645.0 | 645.0 | KOLKATA | WESTBENGAL | LFS | LFS | 20 W Sheer | Classic 20 ml | 2 |
| 9 | 2023-24 | 2023-04-01 | Apr | Q1 | NORTH | 2023-04-18 | NFW01DQ1 | 1.0 | L | TF | SS | SS222 | SS222 | 115-SSL-SALT LAKE KOLKATA | 499 | 499.0 | 499.0 | KOLKATA | WESTBENGAL | LFS | LFS | 150 W Celeste Deo | Premium Deo | 2 |